Chart on chart sheet not printed as desired due to Custom not selected.
Cause:
This problem occurs because the 'Use Full Page' or the 'Scale to Fit Page' option is selected. When the 'Use Full Page' option is selected, Excel enlarges the chart to fit the full page (both width and height) when printing. When the 'Scale to Fit Page' option is selected, Excel enlarges the chart proportionally until one dimension (width or height) reaches the margins.
Solution:
Select 'Page Setup...' from the 'File' menu, click the 'Chart' tab, and select the 'Custom' option in the 'Printed Chart Size' group.
1) Click the tab for the desired chart sheet. (The sheet is selected.)
2) Select the 'File' menu and select 'Page Setup...'. (The Page Setup dialog box appears.)
3) Click 'Chart' tab.
4) Select the 'Custom' radio button in the 'Printed Chart Size' group.
Selecting the Custom option
5) Click 'OK' to save the setting.
6) (Optional) Resize the chart to the desired size.
7) (Optional) Print the chart.
